<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/zhangdefeng2008/article/details/74518773"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"mysql 各种命令（解锁） - zhangdefeng2008"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>mysql 各种命令（解锁） - zhangdefeng2008 - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-9b39979775.min.css">
        <script type="text/javascript">
        var username = "zhangdefeng2008";
        var blog_address = "https://blog.csdn.net/zhangdefeng2008";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/zhangdefeng2008/article/details/74518773"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin3-template";
        // 收藏所需数据
        var articleTitle = "mysql 各种命令（解锁）";
        var articleDesc = "解锁第一种showprocesslist;找到锁进程，killid;第二种mysql>UNLOCKTABLES;锁表锁定数据表，避免在备份过程中，表被更新mysql>LOCKTABLEStbl_nameREAD;为表增加一个写锁定：mysql>LOCKTABLEStbl_nameWRITE;查询是否锁表show";
        // 第四范式所需数据
        var articleTitles = "mysql 各种命令（解锁） - zhangdefeng2008";
        
        var nickName = "zhangdefeng2008";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/zhangdefeng2008/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/zhangdefeng2008/article/details/74518773";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">mysql 各种命令（解锁）</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2017年07月06日 09:51:19</span>
                    <a class="follow-nickName" href="https://me.csdn.net/zhangdefeng2008" target="_blank">zhangdefeng2008</a>
                    <span class="read-count">阅读数 2177</span>
                                    </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                <div class="htmledit_views" id="content_views">
                                            
<span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;">解锁</span><br style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;" /><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;">第一种</span><br style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;" /><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;">show processlist;</span><br style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;" /><p><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;">找到锁进程，kill id ;</span></p>
<p><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;"><br /></span></p>
<p><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;"><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;">第二种</span><br style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;" /><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;">mysql&gt;UNLOCK TABLES;</span><br style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;" /><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;">锁表</span><br style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;" /><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;">锁定数据表，避免在备份过程中，表被更新</span><br style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;" /><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;">mysql&gt;LOCK TABLES tbl_name READ;</span><br style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;" /><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;">为表增加一个写锁定：</span><br style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;" /><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;">mysql&gt;LOCK TABLES tbl_name WRITE;</span><br /></span></p>
<p><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;"><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;"><br /></span></span></p>
<p><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;"><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;"><span style="color:rgb(50,62,50);font-family:'Microsoft YaHei', 'Helvetica Neue', SimSun;font-size:14px;">查询是否锁表</span><br style="color:rgb(50,62,50);font-family:'Microsoft YaHei', 'Helvetica Neue', SimSun;font-size:14px;" /><span style="color:rgb(50,62,50);font-family:'Microsoft YaHei', 'Helvetica Neue', SimSun;font-size:14px;">show OPEN TABLES where In_use &gt; 0;</span><br /></span></span></p>
<p><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;"><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;"><span style="color:rgb(50,62,50);font-family:'Microsoft YaHei', 'Helvetica Neue', SimSun;font-size:14px;">SHOW
 OPEN TABLES;</span></span></span></p>
<p><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;"><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;"><span style="color:rgb(50,62,50);font-family:'Microsoft YaHei', 'Helvetica Neue', SimSun;font-size:14px;">//
 解锁<br />
UNLOCK TABLES;</span></span></span></p>
<p><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;"><span style="color:rgb(57,57,57);font-family:verdana, 'ms song', Arial, Helvetica, sans-serif;font-size:14px;"><span style="color:rgb(50,62,50);font-family:'Microsoft YaHei', 'Helvetica Neue', SimSun;font-size:14px;">查看表的状态<br />
SHOW STATUS LIKE 'table%';<br />
SHOW STATUS LIKE 'innodb_row_lock%';<br /></span></span></span></p>
                                    </div>
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/zhangdefeng2008/article/details/74518773","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/zhangdefeng2008/article/details/74518773","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-402","con":",,"}' data-track-click='{"mod":"kp_popu_58-402","con":",,"}' data-report-view='{"mod":"kp_popu_58-402","keyword":""}' data-report-click='{"mod":"kp_popu_58-402","keyword":""}'><div style="width:100%;background:#fff;border:3px solid #fff;padding:16px 0px 0px 0px;">
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<div id="three_ad1" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 100,
                showid : 'ztvJV8',
                placeholderId: "three_ad1",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 0,
                    imageWidth: 90,
                    imageHeight: 68,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft YaHei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 20,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="74518773">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/liunianerge/article/details/75098391","strategy":"BlogCommendFromMachineLearnPai2","index":"0"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/liunianerge/article/details/75098391","strategy":"BlogCommendFromMachineLearnPai2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/liunianerge/article/details/75098391" target="_blank" title="MYSQL锁表和解锁语句">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em>锁表和<em>解锁</em>语句		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-14</span>
				<span class="read-num hover-hide">
					阅读数 
					280</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/liunianerge/article/details/75098391" target="_blank" title="MYSQL锁表和解锁语句">
				<span class="desc oneline">对于MySQL来说，有三种锁的级别：页级、表级、行级页级的典型代表引擎为BDB。表级的典型代表引擎为MyISAM,MEMORY以及很久以前的ISAM。行级的典型代表引擎为INNODB。-我们实际应用中...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/liunianerge">来自：	<span class="blog_title"> PHP自学辅导</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u012599988/article/details/50295735","strategy":"BlogCommendFromMachineLearnPai2","index":"1"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u012599988/article/details/50295735","strategy":"BlogCommendFromMachineLearnPai2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012599988/article/details/50295735" target="_blank" title="mysql表的死锁解决">
		<h4 class="text-truncate oneline">
				<em>mysql</em>表的死锁解决		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-14</span>
				<span class="read-num hover-hide">
					阅读数 
					292</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012599988/article/details/50295735" target="_blank" title="mysql表的死锁解决">
				<span class="desc oneline">1、查询是否锁表showOPENTABLESwhereIn_use&gt;0;2、查询进程showprocesslist查询到相对应的进程===然后killid...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012599988">来自：	<span class="blog_title"> 半僧</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/jeikerxiao/article/details/81508730","strategy":"BlogCommendFromMachineLearnPai2","index":"2"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jeikerxiao/article/details/81508730","strategy":"BlogCommendFromMachineLearnPai2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jeikerxiao/article/details/81508730" target="_blank" title="MySQL 解锁与锁表">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> <em>解锁</em>与锁表		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-08</span>
				<span class="read-num hover-hide">
					阅读数 
					1020</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jeikerxiao/article/details/81508730" target="_blank" title="MySQL 解锁与锁表">
				<span class="desc oneline">1.查看正在被锁定的表showOPENTABLESwhereIn_use&amp;amp;gt;0;2.查看表状态showstatuslike'table%';Table_locks_immediate指的是...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jeikerxiao">来自：	<span class="blog_title"> jeikerxiao</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u010735147/article/details/81588187","strategy":"BlogCommendFromMachineLearnPai2","index":"3"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u010735147/article/details/81588187","strategy":"BlogCommendFromMachineLearnPai2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010735147/article/details/81588187" target="_blank" title="mysql锁表查询和解锁操作">
		<h4 class="text-truncate oneline">
				<em>mysql</em>锁表查询和<em>解锁</em>操作		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-11</span>
				<span class="read-num hover-hide">
					阅读数 
					7280</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010735147/article/details/81588187" target="_blank" title="mysql锁表查询和解锁操作">
				<span class="desc oneline">mysql锁表查询和解锁操作1、在做数据库操作时，有时会因为自己的粗心或者程序设计上的缺陷导致锁表，在mysql中查看锁表和解锁的步骤如下：//1.查看当前数据库锁表的情况SELECT*FROMinf...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010735147">来自：	<span class="blog_title"> 贾维斯的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-860","con":",,SQL"}' data-track-click='{"mod":"kp_popu_59-860","con":",,SQL"}' data-report-view='{"mod":"kp_popu_59-860","keyword":"SQL"}' data-report-click='{"mod":"kp_popu_59-860","keyword":"SQL"}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/109?positionId=59&queryWord=SQL" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/nddjava/article/details/44063413","strategy":"BlogCommendFromMachineLearnPai2","index":"4"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/nddjava/article/details/44063413","strategy":"BlogCommendFromMachineLearnPai2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/nddjava/article/details/44063413" target="_blank" title="mysql  查看锁表解锁">
		<h4 class="text-truncate oneline">
				<em>mysql</em>  查看锁表<em>解锁</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-04</span>
				<span class="read-num hover-hide">
					阅读数 
					4万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/nddjava/article/details/44063413" target="_blank" title="mysql  查看锁表解锁">
				<span class="desc oneline">--查看那些表锁到了showOPENTABLESwhereIn_use&gt;0;--查看进程号showprocesslist;--删除进程 kill1085850；...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/nddjava">来自：	<span class="blog_title"> nddjava的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_35242653/article/details/82805186","strategy":"BlogCommendFromBaidu","index":"5"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_35242653/article/details/82805186","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_35242653/article/details/82805186" target="_blank" title="mysql 查看锁表解锁">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 查看锁表<em>解锁</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-25</span>
				<span class="read-num hover-hide">
					阅读数 
					840</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_35242653/article/details/82805186" target="_blank" title="mysql 查看锁表解锁">
				<span class="desc oneline">--查看那些表锁到了showOPENTABLESwhereIn_use&amp;amp;gt;0;--查看进程号showprocesslist;--删除进程 kill1085850； ...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_35242653">来自：	<span class="blog_title"> 木头人的备忘录</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_33894640/article/details/92959178","strategy":"BlogCommendFromBaidu","index":"6"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_33894640/article/details/92959178","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_33894640/article/details/92959178" target="_blank" title="mysql 查询表死锁 和结束死锁的表步骤">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 查询表死锁 和结束死锁的表步骤		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-15</span>
				<span class="read-num hover-hide">
					阅读数 
					1</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_33894640/article/details/92959178" target="_blank" title="mysql 查询表死锁 和结束死锁的表步骤">
				<span class="desc oneline">1、查询是否锁表showOPENTABLESwhereIn_use&amp;gt;0;2、查询进程showprocesslist查询到相对应的进程===然后killid补充：查看正在锁的事务SELECT*FR...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_33894640">来自：	<span class="blog_title"> weixin_33894640的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_16736531/article/details/52604999","strategy":"BlogCommendFromBaidu","index":"7"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_16736531/article/details/52604999","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_16736531/article/details/52604999" target="_blank" title="当提示mysql数据库被锁解锁方法">
		<h4 class="text-truncate oneline">
				当提示<em>mysql</em>数据库被锁<em>解锁</em>方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-21</span>
				<span class="read-num hover-hide">
					阅读数 
					1541</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_16736531/article/details/52604999" target="_blank" title="当提示mysql数据库被锁解锁方法">
				<span class="desc oneline">##--查看数据库的进程：SHOWPROCESSLIST;##--执行查询所用库的所有的进程，并完成kill语句拼写： select concat('kill ',id,';') from infor...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_16736531">来自：	<span class="blog_title"> 天上的海风博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/bowen_bao/article/details/78759868","strategy":"BlogCommendFromBaidu","index":"8"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/bowen_bao/article/details/78759868","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/bowen_bao/article/details/78759868" target="_blank" title="mysql 解锁">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>解锁</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-09</span>
				<span class="read-num hover-hide">
					阅读数 
					195</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/bowen_bao/article/details/78759868" target="_blank" title="mysql 解锁">
				<span class="desc oneline">KILL ( SELECT idFROMinformation_schema.processlist   )</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/bowen_bao">来自：	<span class="blog_title"> bowen_bao的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34122548/article/details/93185047","strategy":"BlogCommendFromBaidu","index":"9"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34122548/article/details/93185047","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34122548/article/details/93185047" target="_blank" title="如何将数据库账号（用户）解锁">
		<h4 class="text-truncate oneline">
				如何将数据库账号（用户）<em>解锁</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-05</span>
				<span class="read-num hover-hide">
					阅读数 
					11</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34122548/article/details/93185047" target="_blank" title="如何将数据库账号（用户）解锁">
				<span class="desc oneline">--1ALTERUSERusernameACCOUNTUNLOCK;--2sqlplus/assysdbaalterusersystemaccountunlock--3默认的scott用户是被锁定的，...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34122548">来自：	<span class="blog_title"> weixin_34122548的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/liuaixi200/article/details/79044914","strategy":"BlogCommendFromBaidu","index":"10"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/liuaixi200/article/details/79044914","strategy":"BlogCommendFromBaidu","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/liuaixi200/article/details/79044914" target="_blank" title="mysql序列引发的锁问题">
		<h4 class="text-truncate oneline">
				<em>mysql</em>序列引发的锁问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-12</span>
				<span class="read-num hover-hide">
					阅读数 
					532</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/liuaixi200/article/details/79044914" target="_blank" title="mysql序列引发的锁问题">
				<span class="desc oneline">今天处理一个mysql序列，结果发现两个事物同时开启会出现并发的情况，查出的序列是相同的。以下为还原步骤：1创建表：CREATETABLE`tb_sequence`( `name`varchar(50...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/liuaixi200">来自：	<span class="blog_title"> liuaixi200的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/ldl22847/article/details/8612660","strategy":"BlogCommendFromBaidu","index":"11"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/ldl22847/article/details/8612660","strategy":"BlogCommendFromBaidu","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ldl22847/article/details/8612660" target="_blank" title="无法锁定管理目录(/var/lib/dpkg/)，是否有其他进程正占用它？">
		<h4 class="text-truncate oneline">
				无法锁定管理目录(/var/lib/dpkg/)，是否有其他进程正占用它？		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-26</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ldl22847/article/details/8612660" target="_blank" title="无法锁定管理目录(/var/lib/dpkg/)，是否有其他进程正占用它？">
				<span class="desc oneline">Error:E:无法获得锁/var/lib/dpkg/lock-open(11:Resourcetemporarilyunavailable)E:无法锁定管理目录(/var/lib/dpkg/)，是否...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ldl22847">来自：	<span class="blog_title"> 东亮博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/fang_liu123/article/details/48756823","strategy":"BlogCommendFromBaidu","index":"12"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/fang_liu123/article/details/48756823","strategy":"BlogCommendFromBaidu","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/fang_liu123/article/details/48756823" target="_blank" title="ubuntu_解锁文件命令">
		<h4 class="text-truncate oneline">
				ubuntu_<em>解锁</em>文件<em>命令</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-26</span>
				<span class="read-num hover-hide">
					阅读数 
					2408</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/fang_liu123/article/details/48756823" target="_blank" title="ubuntu_解锁文件命令">
				<span class="desc oneline">解锁文件夹及子文件chmod a+w文件名-R解锁文件chmod a+w文件名  可以解锁，主要是授权可读写执行的权限sudochmod-R777文件名chmod能改变权限，-R目录下所有文件， 77...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/fang_liu123">来自：	<span class="blog_title"> liutest_926的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/iteye_4195/article/details/82477495","strategy":"BlogCommendFromBaidu","index":"13"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/iteye_4195/article/details/82477495","strategy":"BlogCommendFromBaidu","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/iteye_4195/article/details/82477495" target="_blank" title="MySQL锁定状态查看命令">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>锁定状态查看<em>命令</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-07</span>
				<span class="read-num hover-hide">
					阅读数 
					15</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/iteye_4195/article/details/82477495" target="_blank" title="MySQL锁定状态查看命令">
				<span class="desc oneline">1showprocesslist;SHOWPROCESSLIST显示哪些线程正在运行。您也可以使用mysqladminprocesslist语句得到此信息。如果您有SUPER权限，您可以看到所有线程。...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/iteye_4195">来自：	<span class="blog_title"> 系统运维</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/hjgzj/article/details/79630264","strategy":"searchFromBaidu","index":"14"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hjgzj/article/details/79630264","strategy":"searchFromBaidu","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hjgzj/article/details/79630264" target="_blank" title="mysql查询锁表以及解锁">
		<h4 class="text-truncate oneline">
				<em>mysql</em>查询锁表以及<em>解锁</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-20</span>
				<span class="read-num hover-hide">
					阅读数 
					349</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hjgzj/article/details/79630264" target="_blank" title="mysql查询锁表以及解锁">
				<span class="desc oneline">查询使用中的表：showOPENTABLESwhereIn_use&amp;amp;gt;0;查询进程：showprocesslist; 看command，不是sleep就把id放到下面的sql中结束进程（解...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hjgzj">来自：	<span class="blog_title"> 韩俊的个人博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box recommend-box-ident recommend-download-box clearfix" data-report-view='{"mod":"popu_387","dest":"https://download.csdn.net/download/liujiaozhu25/11286471","strategy":"BlogCommendFromQuerySearch","index":"15"}' data-report-click='{"mod":"popu_387","dest":"https://download.csdn.net/download/liujiaozhu25/11286471","strategy":"BlogCommendFromQuerySearch","index":"15"}'>
		<a href="https://download.csdn.net/download/liujiaozhu25/11286471" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						C:\Users\liuwei\Desktop\oracle<em>解锁</em><em>命令</em>.txt					</h4>
					<span class="data float-right">07-05</span>
				</div>
				<div class="desc oneline">
						oracle解锁命令oracle解锁命令oracle解锁命令oracle解锁命令				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/itao1067/article/details/76851231","strategy":"BlogCommendFromQuerySearch","index":"16"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/itao1067/article/details/76851231","strategy":"BlogCommendFromQuerySearch","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/itao1067/article/details/76851231" target="_blank" title="oracle/mysql查看锁表与解锁表">
		<h4 class="text-truncate oneline">
				oracle/<em>mysql</em>查看锁表与<em>解锁</em>表		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-07</span>
				<span class="read-num hover-hide">
					阅读数 
					383</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/itao1067/article/details/76851231" target="_blank" title="oracle/mysql查看锁表与解锁表">
				<span class="desc oneline">在开发的时候，有时候不管是通过cmd操作数据库、还是通过数据库工具操作数据库，有时候不正当的操作会将表锁了：从开发的角度来看，表现为当在程序中通过代码对数据库进行更新、删除、添加操作时候，代码执行无效...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/itao1067">来自：	<span class="blog_title"> try_my_best</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/cfyme/article/details/84712283","strategy":"BlogCommendFromQuerySearch","index":"17"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/cfyme/article/details/84712283","strategy":"BlogCommendFromQuerySearch","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/cfyme/article/details/84712283" target="_blank" title="查询mysql 锁表">
		<h4 class="text-truncate oneline">
				查询<em>mysql</em> 锁表		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-15</span>
				<span class="read-num hover-hide">
					阅读数 
					55</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/cfyme/article/details/84712283" target="_blank" title="查询mysql 锁表">
				<span class="desc oneline">查询mysql哪些表正在被锁状态 showOPENTABLESwhereIn_use&amp;amp;gt;0; showprocesslist;showfullprocesslist; killid //杀...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/cfyme">来自：	<span class="blog_title"> 会当凌绝顶 一览众山小</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box recommend-box-ident recommend-download-box clearfix" data-report-view='{"mod":"popu_387","dest":"https://download.csdn.net/download/qq_31103453/9083889","strategy":"BlogCommendFromQuerySearch","index":"18"}' data-report-click='{"mod":"popu_387","dest":"https://download.csdn.net/download/qq_31103453/9083889","strategy":"BlogCommendFromQuerySearch","index":"18"}'>
		<a href="https://download.csdn.net/download/qq_31103453/9083889" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						<em>解锁</em>包，<em>各种</em><em>解锁</em>					</h4>
					<span class="data float-right">09-06</span>
				</div>
				<div class="desc oneline">
						手机解锁，一件刷机，救砖* 如涉及侵权内容,您的资源将被移除
* 请勿上传小说、mp3、图片等与技术无关的内容.一旦发现将被删除
* 请勿在未经授权的情况下上传任何涉及著作权侵权的资源，除非该资源完全由您个人创作
* 点击上传资源即表示您...				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-1062","con":",,"}' data-track-click='{"mod":"kp_popu_62-1062","con":",,"}' data-report-view='{"mod":"kp_popu_62-1062","keyword":""}' data-report-click='{"mod":"kp_popu_62-1062","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/237?positionId=62&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34247299/article/details/92150201","strategy":"BlogCommendFromMachineLearnPai2","index":"19"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34247299/article/details/92150201","strategy":"BlogCommendFromMachineLearnPai2","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34247299/article/details/92150201" target="_blank" title="mysql中kill掉所有锁表的进程">
		<h4 class="text-truncate oneline">
				<em>mysql</em>中kill掉所有锁表的进程		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-13</span>
				<span class="read-num hover-hide">
					阅读数 
					10</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34247299/article/details/92150201" target="_blank" title="mysql中kill掉所有锁表的进程">
				<span class="desc oneline">mysql&amp;gt;showprocesslist;出来哗啦啦好几屏幕的,没有一千也有几百条,查询语句把表锁住了,赶紧找出第一个Locked的thread_id,在mysql的shell里面执行.mys...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34247299">来自：	<span class="blog_title"> weixin_34247299的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/LiuXingSiYe/article/details/39582345","strategy":"BlogCommendFromMachineLearnPai2","index":"20"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/LiuXingSiYe/article/details/39582345","strategy":"BlogCommendFromMachineLearnPai2","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/LiuXingSiYe/article/details/39582345" target="_blank" title="MySql三种级别锁的介绍及解锁命令">
		<h4 class="text-truncate oneline">
				<em>MySql</em>三种级别锁的介绍及<em>解锁</em><em>命令</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-26</span>
				<span class="read-num hover-hide">
					阅读数 
					1187</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/LiuXingSiYe/article/details/39582345" target="_blank" title="MySql三种级别锁的介绍及解锁命令">
				<span class="desc oneline">页级的典型代表引擎为BDB。表级的典型代表引擎为MyISAM,MEMORY以及很久以前的ISAM。行级的典型代表引擎为INNODB。-我们实际应用中用的最多的就是行锁。行级锁的优点如下：1）、当很多连...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/LiuXingSiYe">来自：	<span class="blog_title"> @胖虎</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_37581708/article/details/73926072","strategy":"BlogCommendFromBaidu","index":"21"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_37581708/article/details/73926072","strategy":"BlogCommendFromBaidu","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_37581708/article/details/73926072" target="_blank" title="mysql解锁行锁定">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>解锁</em>行锁定		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-29</span>
				<span class="read-num hover-hide">
					阅读数 
					1287</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_37581708/article/details/73926072" target="_blank" title="mysql解锁行锁定">
				<span class="desc oneline">1.查看下在锁的事务 SELECT*FROMINFORMATION_SCHEMA.INNODB_TRX;2.杀死进程id（就是上面命令的trx_mysql_thread_id列）kill线程ID...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_37581708">来自：	<span class="blog_title"> 辰辰呐的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/Yoara/article/details/56486079","strategy":"BlogCommendFromBaidu","index":"22"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Yoara/article/details/56486079","strategy":"BlogCommendFromBaidu","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Yoara/article/details/56486079" target="_blank" title="Mysql锁查询相关指令">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>锁查询相关指令		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-22</span>
				<span class="read-num hover-hide">
					阅读数 
					522</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Yoara/article/details/56486079" target="_blank" title="Mysql锁查询相关指令">
				<span class="desc oneline">msyql锁查询相关</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Yoara">来自：	<span class="blog_title"> Yoara的备忘录</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u013703963/article/details/54173967","strategy":"BlogCommendFromBaidu","index":"23"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u013703963/article/details/54173967","strategy":"BlogCommendFromBaidu","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u013703963/article/details/54173967" target="_blank" title="MySQL的读锁和解锁">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>的读锁和<em>解锁</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-07</span>
				<span class="read-num hover-hide">
					阅读数 
					548</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u013703963/article/details/54173967" target="_blank" title="MySQL的读锁和解锁">
				<span class="desc oneline">读锁和解锁其实只是一句SQL语句，语法LOCK/UNLOCKTABLEStbl_name[[AS]alias]lock_type[,tbl_name[[AS]alias]lock_type]等等loc...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u013703963">来自：	<span class="blog_title"> 锦衣卫的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-1059","con":",,"}' data-track-click='{"mod":"kp_popu_63-1059","con":",,"}' data-report-view='{"mod":"kp_popu_63-1059","keyword":""}' data-report-click='{"mod":"kp_popu_63-1059","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/234?positionId=63&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/sinat_29461437/article/details/78113250","strategy":"BlogCommendFromBaidu","index":"24"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/sinat_29461437/article/details/78113250","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sinat_29461437/article/details/78113250" target="_blank" title="详解MySQL的用户密码过期/锁定解锁功能">
		<h4 class="text-truncate oneline">
				详解<em>MySQL</em>的用户密码过期/锁定<em>解锁</em>功能		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-27</span>
				<span class="read-num hover-hide">
					阅读数 
					3384</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sinat_29461437/article/details/78113250" target="_blank" title="详解MySQL的用户密码过期/锁定解锁功能">
				<span class="desc oneline">mysql&gt;ALTERUSER'testuser'@'localhost'PASSWORDEXPIRE;</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sinat_29461437">来自：	<span class="blog_title"> kappe_bj</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/PHPService/article/details/54931628","strategy":"BlogCommendFromBaidu","index":"25"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/PHPService/article/details/54931628","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/PHPService/article/details/54931628" target="_blank" title="mysql 表锁定，库锁定">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 表锁定，库锁定		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-08</span>
				<span class="read-num hover-hide">
					阅读数 
					6239</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/PHPService/article/details/54931628" target="_blank" title="mysql 表锁定，库锁定">
				<span class="desc oneline">今天在解决数据库同步异常的时候用到了flushtableswithreadlock这个命令，于是顺便就学习了下锁表的相关知识。 1.FLUSHTABLESWITHREADLOCK 这个命令是全局读锁定...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/PHPService">来自：	<span class="blog_title"> 追逐</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/chszs/article/details/50651264","strategy":"BlogCommendFromBaidu","index":"26"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/chszs/article/details/50651264","strategy":"BlogCommendFromBaidu","index":"26"}'>
	<div class="content">
		<a href="https://blog.csdn.net/chszs/article/details/50651264" target="_blank" title="MySQL的用户密码过期功能详解">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>的用户密码过期功能详解		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-11</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/chszs/article/details/50651264" target="_blank" title="MySQL的用户密码过期功能详解">
				<span class="desc oneline">MySQL的用户密码过期功能详解作者：chszs，未经博主允许不得转载。经许可的转载需注明作者和博客主页：http://blog.csdn.net/chszs先说明两个术语。PaymentCardIn...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/chszs">来自：	<span class="blog_title"> chszs的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u010931123/article/details/85065353","strategy":"BlogCommendFromQuerySearch","index":"27"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u010931123/article/details/85065353","strategy":"BlogCommendFromQuerySearch","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010931123/article/details/85065353" target="_blank" title="解锁mysql数据库表">
		<h4 class="text-truncate oneline">
				<em>解锁</em><em>mysql</em>数据库表		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-18</span>
				<span class="read-num hover-hide">
					阅读数 
					136</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010931123/article/details/85065353" target="_blank" title="解锁mysql数据库表">
				<span class="desc oneline">解锁第一种showprocesslist;找到锁进程，killid; 第二种mysql&amp;amp;gt;UNLOCKTABLES;</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010931123">来自：	<span class="blog_title"> 麦子的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box recommend-box-ident recommend-download-box clearfix" data-report-view='{"mod":"popu_387","dest":"https://download.csdn.net/download/baidu_41672657/10755992","strategy":"BlogCommendFromQuerySearch","index":"28"}' data-report-click='{"mod":"popu_387","dest":"https://download.csdn.net/download/baidu_41672657/10755992","strategy":"BlogCommendFromQuerySearch","index":"28"}'>
		<a href="https://download.csdn.net/download/baidu_41672657/10755992" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						fastboot-<em>解锁</em>使用说明					</h4>
					<span class="data float-right">10-31</span>
				</div>
				<div class="desc oneline">
						adb工具包下载解压，如放在D:\adb_tools-2.0目录（可以直接放到C:\Windows\System32目录中，使用cmd命令时不需要再切换目录了）。

手机进入fastboot模式：先将手机关机，然后同时按下音量下键以及开机...				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-81","con":",,"}' data-track-click='{"mod":"kp_popu_64-81","con":",,"}' data-report-view='{"mod":"kp_popu_64-81","keyword":""}' data-report-click='{"mod":"kp_popu_64-81","keyword":""}'><div id="three_ad28" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad28",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/xiaobaiing/article/details/51363835","strategy":"BlogCommendFromQuerySearch","index":"29"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xiaobaiing/article/details/51363835","strategy":"BlogCommendFromQuerySearch","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xiaobaiing/article/details/51363835" target="_blank" title="Android通过指令模拟touch滑动解锁">
		<h4 class="text-truncate oneline">
				Android通过指令模拟touch滑动<em>解锁</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-10</span>
				<span class="read-num hover-hide">
					阅读数 
					6975</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xiaobaiing/article/details/51363835" target="_blank" title="Android通过指令模拟touch滑动解锁">
				<span class="desc oneline">﻿﻿手机上有很多输入设备，电源键、音量加减键、触屏等等。这些设备的编号会因每个手机不同而不同，因此我们需要首先了解这个手机上都有哪些输入设备，然后通过脚本操作这些输入设备，实现一些想要的操作，进而通过...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xiaobaiing">来自：	<span class="blog_title"> 小白的IT旅程</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box recommend-box-ident recommend-download-box clearfix" data-report-view='{"mod":"popu_387","dest":"https://download.csdn.net/download/dingding5060/3832948","strategy":"BlogCommendFromQuerySearch","index":"30"}' data-report-click='{"mod":"popu_387","dest":"https://download.csdn.net/download/dingding5060/3832948","strategy":"BlogCommendFromQuerySearch","index":"30"}'>
		<a href="https://download.csdn.net/download/dingding5060/3832948" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						赋予数据库断点权限以及数据库<em>解锁</em><em>命令</em>					</h4>
					<span class="data float-right">11-23</span>
				</div>
				<div class="desc oneline">
						赋予数据库断点权限以及数据库解锁命令
数据库 断点权限 解锁 命令				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/sai739295732/article/details/50785924","strategy":"BlogCommendFromBaidu","index":"31"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/sai739295732/article/details/50785924","strategy":"BlogCommendFromBaidu","index":"31"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sai739295732/article/details/50785924" target="_blank" title="mysql 查询死锁以及解锁">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 查询死锁以及<em>解锁</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-03</span>
				<span class="read-num hover-hide">
					阅读数 
					4619</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sai739295732/article/details/50785924" target="_blank" title="mysql 查询死锁以及解锁">
				<span class="desc oneline">mysql查询死锁以及解锁</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sai739295732">来自：	<span class="blog_title"> 史上最强的弟子</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/james23Chosen1/article/details/79461233","strategy":"BlogCommendFromBaidu","index":"32"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/james23Chosen1/article/details/79461233","strategy":"BlogCommendFromBaidu","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/james23Chosen1/article/details/79461233" target="_blank" title="Mysql解锁">
		<h4 class="text-truncate oneline">
				<em>Mysql</em><em>解锁</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-06</span>
				<span class="read-num hover-hide">
					阅读数 
					106</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/james23Chosen1/article/details/79461233" target="_blank" title="Mysql解锁">
				<span class="desc oneline">看到乐观锁悲观锁，就测试了一下。结果，在开启事务后没有Commit。mysql第一次上锁没有提交.第二次就锁不了了，没法执行下面的程序。输出不了User。//悲观锁	@Test	publicvoidr...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/james23Chosen1">来自：	<span class="blog_title"> james23Chosen1的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/halou90/article/details/50395037","strategy":"BlogCommendFromBaidu","index":"33"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/halou90/article/details/50395037","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/halou90/article/details/50395037" target="_blank" title="MySql中Lock命令和unlock命令">
		<h4 class="text-truncate oneline">
				<em>MySql</em>中Lock<em>命令</em>和unlock<em>命令</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-24</span>
				<span class="read-num hover-hide">
					阅读数 
					418</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/halou90/article/details/50395037" target="_blank" title="MySql中Lock命令和unlock命令">
				<span class="desc oneline">在同一个连接当中，执行了一次locktable之后，如果再次执行locktable，那么之前被锁住的表就自动解锁了。下面这张图可以证明：--------------------------------...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/halou90">来自：	<span class="blog_title"> Halou_Oracle Halou_MySQL Halou_Mongo Halou_HBase</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-1061","con":",,"}' data-track-click='{"mod":"kp_popu_65-1061","con":",,"}' data-report-view='{"mod":"kp_popu_65-1061","keyword":""}' data-report-click='{"mod":"kp_popu_65-1061","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/236?positionId=65&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_33861800/article/details/86105792","strategy":"BlogCommendFromBaidu","index":"34"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_33861800/article/details/86105792","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_33861800/article/details/86105792" target="_blank" title="mysql锁表和解锁语句分享">
		<h4 class="text-truncate oneline">
				<em>mysql</em>锁表和<em>解锁</em>语句分享		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-09</span>
				<span class="read-num hover-hide">
					阅读数 
					7</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_33861800/article/details/86105792" target="_blank" title="mysql锁表和解锁语句分享">
				<span class="desc oneline">转载自:网络.对于MySQL来说，有三种锁的级别：页级、表级、行级页级的典型代表引擎为BDB。 表级的典型代表引擎为MyISAM,MEMORY以及很久以前的ISAM。 行级的典型代表引擎为INNODB...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_33861800">来自：	<span class="blog_title"> weixin_33861800的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/lihm0_1/article/details/86677000","strategy":"BlogCommendFromBaidu","index":"35"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lihm0_1/article/details/86677000","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lihm0_1/article/details/86677000" target="_blank" title="mysql8定位被锁语句">
		<h4 class="text-truncate oneline">
				<em>mysql</em>8定位被锁语句		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-28</span>
				<span class="read-num hover-hide">
					阅读数 
					251</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lihm0_1/article/details/86677000" target="_blank" title="mysql8定位被锁语句">
				<span class="desc oneline">线上mysql版本为8.0.11，对于最近的几个版本越来越像Orale了，有了较为丰富的系统字典，也可以查看系统的等待事件，现在线上出现被锁语句的情况也可以通过数据字典直接查询出来了，在此记录下以供参...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lihm0_1">来自：	<span class="blog_title"> 海盗的小菜园</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/lixungogogo/article/details/75414685","strategy":"BlogCommendFromQuerySearch","index":"36"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lixungogogo/article/details/75414685","strategy":"BlogCommendFromQuerySearch","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lixungogogo/article/details/75414685" target="_blank" title="Linux下Mysql常用命令总结">
		<h4 class="text-truncate oneline">
				Linux下<em>Mysql</em>常用<em>命令</em>总结		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-19</span>
				<span class="read-num hover-hide">
					阅读数 
					2021</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lixungogogo/article/details/75414685" target="_blank" title="Linux下Mysql常用命令总结">
				<span class="desc oneline">很久没有写博客啦，大概有一年了，还记得以前找工作前疯狂的总结，后期慢慢的有些懈怠，最近总结了一下自己的问题，觉得博客这个方式是一个很好的学习方式，还是不能丢掉，所以今天又开始写博客啦，如果是师妹师弟看...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lixungogogo">来自：	<span class="blog_title"> lixungogogo的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/lml282518588/article/details/52291494","strategy":"BlogCommendFromQuerySearch","index":"37"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lml282518588/article/details/52291494","strategy":"BlogCommendFromQuerySearch","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lml282518588/article/details/52291494" target="_blank" title="【Sqlserver】各种数据库的锁表和解锁操作">
		<h4 class="text-truncate oneline">
				【Sqlserver】<em>各种</em>数据库的锁表和<em>解锁</em>操作		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-23</span>
				<span class="read-num hover-hide">
					阅读数 
					8579</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lml282518588/article/details/52291494" target="_blank" title="【Sqlserver】各种数据库的锁表和解锁操作">
				<span class="desc oneline">SqlServer查询被锁住的表和解锁表--1.查看被锁表：SELECTrequest_session_idasspid,OBJECT_NAME(resource_associated_entity_...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lml282518588">来自：	<span class="blog_title"> Insist</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34279579/article/details/90326947","strategy":"BlogCommendFromQuerySearch","index":"38"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34279579/article/details/90326947","strategy":"BlogCommendFromQuerySearch","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34279579/article/details/90326947" target="_blank" title="Android 如何从底层解锁？AT指令的操作">
		<h4 class="text-truncate oneline">
				Android 如何从底层<em>解锁</em>？AT指令的操作		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-15</span>
				<span class="read-num hover-hide">
					阅读数 
					10</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34279579/article/details/90326947" target="_blank" title="Android 如何从底层解锁？AT指令的操作">
				<span class="desc oneline">看此篇文章之前大致先了解什么是AT指令，AT命令（Attention）在手机中，用于对modem（也就是移动模块）通过串口命令进行操作，处理与语音电话、短信和数据。其实安卓的拨打电话之类，底层执行的都...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34279579">来自：	<span class="blog_title"> weixin_34279579的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/melo_fang/article/details/79480866","strategy":"BlogCommendFromQuerySearch","index":"39"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/melo_fang/article/details/79480866","strategy":"BlogCommendFromQuerySearch","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/melo_fang/article/details/79480866" target="_blank" title="Adb  解锁">
		<h4 class="text-truncate oneline">
				Adb  <em>解锁</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-08</span>
				<span class="read-num hover-hide">
					阅读数 
					6417</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/melo_fang/article/details/79480866" target="_blank" title="Adb  解锁">
				<span class="desc oneline">adbshellinputkeyevent82可以解锁android手机屏幕，前提是android手机屏幕设置的锁屏模式是滑动或者swipe...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/melo_fang">来自：	<span class="blog_title"> melo_fang的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/maqingbin8888/article/details/84679513","strategy":"BlogCommendFromQuerySearch","index":"40"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/maqingbin8888/article/details/84679513","strategy":"BlogCommendFromQuerySearch","index":"40"}'>
	<div class="content">
		<a href="https://blog.csdn.net/maqingbin8888/article/details/84679513" target="_blank" title="mysql_全局锁表锁">
		<h4 class="text-truncate oneline">
				<em>mysql</em>_全局锁表锁		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-01</span>
				<span class="read-num hover-hide">
					阅读数 
					202</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/maqingbin8888/article/details/84679513" target="_blank" title="mysql_全局锁表锁">
				<span class="desc oneline">全局锁、表级锁、行级锁全局锁对整个数据库实例加锁,MySQL提供加全局读锁的方法：Flushtableswithreadlock(FTWRL) 会使整个库处理只读状态使用场景:全库逻辑备份风险:主库备...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/maqingbin8888">来自：	<span class="blog_title"> maqingbin8888的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/rongge2008/article/details/42527607","strategy":"BlogCommendFromBaidu","index":"41"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/rongge2008/article/details/42527607","strategy":"BlogCommendFromBaidu","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/rongge2008/article/details/42527607" target="_blank" title="MYSQL 解锁与锁表">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em> <em>解锁</em>与锁表		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-08</span>
				<span class="read-num hover-hide">
					阅读数 
					334</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/rongge2008/article/details/42527607" target="_blank" title="MYSQL 解锁与锁表">
				<span class="desc oneline">解锁第一种showprocesslist;找到锁进程，killid; 第二种mysql&gt;UNLOCKTABLES;锁表锁定数据表，避免在备份过程中，表被更新mysql&gt;LOCKTABLEStbl_na...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/rongge2008">来自：	<span class="blog_title"> rongge2008的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/xxmzumeng/article/details/37883303","strategy":"BlogCommendFromBaidu","index":"42"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xxmzumeng/article/details/37883303","strategy":"BlogCommendFromBaidu","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xxmzumeng/article/details/37883303" target="_blank" title="MySQL锁表解决方法（转）">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>锁表解决方法（转）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-16</span>
				<span class="read-num hover-hide">
					阅读数 
					7万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xxmzumeng/article/details/37883303" target="_blank" title="MySQL锁表解决方法（转）">
				<span class="desc oneline">MySQL锁表解决方法一、我的处理过程1、查进程，主要是查找被锁表的那个进程的IDSHOWPROCESSLIST;2、kill掉锁表的进程IDKILL 10866;//后面的数字即时进程的ID网上找了...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xxmzumeng">来自：	<span class="blog_title"> xxmzumeng的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/shimch/article/details/626213","strategy":"BlogCommendFromBaidu","index":"43"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/shimch/article/details/626213","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/shimch/article/details/626213" target="_blank" title="Mysql锁定表/解锁句法">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>锁定表/<em>解锁</em>句法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-16</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/shimch/article/details/626213" target="_blank" title="Mysql锁定表/解锁句法">
				<span class="desc oneline">6.7.2LOCKTABLES/UNLOCKTABLES句法LOCKTABLEStbl_name[ASalias]{READ[LOCAL]|[LOW_PRIORITY]WRITE}[,tbl_name...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/shimch">来自：	<span class="blog_title"> shimch的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-653","con":",,"}' data-track-click='{"mod":"kp_popu_67-653","con":",,"}' data-report-view='{"mod":"kp_popu_67-653","keyword":""}' data-report-click='{"mod":"kp_popu_67-653","keyword":""}'><div id="three_ad43" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : '9gAEHz',
                placeholderId: "three_ad43",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 12,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/braveheartzj/article/details/52878276","strategy":"BlogCommendFromBaidu","index":"44"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/braveheartzj/article/details/52878276","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<div class="content">
		<a href="https://blog.csdn.net/braveheartzj/article/details/52878276" target="_blank" title="mysql表锁、行锁和页锁的解析">
		<h4 class="text-truncate oneline">
				<em>mysql</em>表锁、行锁和页锁的解析		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-20</span>
				<span class="read-num hover-hide">
					阅读数 
					823</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/braveheartzj/article/details/52878276" target="_blank" title="mysql表锁、行锁和页锁的解析">
				<span class="desc oneline">页级:引擎BDB。表级:引擎MyISAM，理解为锁住整个表，可以同时读，写不行行级:引擎INNODB，单独的一行记录加锁表级，直接锁定整张表，在你锁定期间，其它进程无法对该表进行写操作。如果你是写锁，...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/braveheartzj">来自：	<span class="blog_title"> braveheartzj的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_41453285/article/details/88054383","strategy":"BlogCommendFromBaidu","index":"45"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_41453285/article/details/88054383","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_41453285/article/details/88054383" target="_blank" title="MySQL：19---MySQL加密/解密，加锁/解锁函数">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>：19---<em>MySQL</em>加密/解密，加锁/<em>解锁</em>函数		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-01</span>
				<span class="read-num hover-hide">
					阅读数 
					116</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_41453285/article/details/88054383" target="_blank" title="MySQL：19---MySQL加密/解密，加锁/解锁函数">
				<span class="desc oneline">一、密码加密函数password(str);//从原明文密码str计算并返回加密后的密码字符串str为NULL，返回NULL	password在MySQL服务器鉴定系统中使用。不应该用在个人的应用程序...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_41453285">来自：	<span class="blog_title"> 江南、董少</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box recommend-box-ident recommend-download-box clearfix" data-report-view='{"mod":"popu_387","dest":"https://download.csdn.net/download/y_linspace2/1496805","strategy":"BlogCommendFromQuerySearch","index":"46"}' data-report-click='{"mod":"popu_387","dest":"https://download.csdn.net/download/y_linspace2/1496805","strategy":"BlogCommendFromQuerySearch","index":"46"}'>
		<a href="https://download.csdn.net/download/y_linspace2/1496805" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						<em>mysql</em>启动<em>命令</em>批处理文件					</h4>
					<span class="data float-right">07-17</span>
				</div>
				<div class="desc oneline">
						mysql启动命令mysql启动命令mysql启动命令mysql启动命令mysql启动命令mysql启动命令mysql启动命令mysql启动命令mysql启动命令mysql启动命令mysql启动命令mysql启动命令mysql启动命令my...				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/hong_leiding/article/details/50981828","strategy":"BlogCommendFromQuerySearch","index":"47"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hong_leiding/article/details/50981828","strategy":"BlogCommendFromQuerySearch","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hong_leiding/article/details/50981828" target="_blank" title="linux上连接的数据库命令，及解锁表">
		<h4 class="text-truncate oneline">
				linux上连接的数据库<em>命令</em>，及<em>解锁</em>表		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-25</span>
				<span class="read-num hover-hide">
					阅读数 
					344</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hong_leiding/article/details/50981828" target="_blank" title="linux上连接的数据库命令，及解锁表">
				<span class="desc oneline">进入db2安装目录下：/db2/software/V10.5.6/bin执行一下命令：db2  --进入db2中connecttoUSPWFuserUSPWFusingz7izSM0K        ...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hong_leiding">来自：	<span class="blog_title"> hong_leiding的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box recommend-box-ident recommend-download-box clearfix" data-report-view='{"mod":"popu_387","dest":"https://download.csdn.net/download/jzh333/10017044","strategy":"BlogCommendFromQuerySearch","index":"48"}' data-report-click='{"mod":"popu_387","dest":"https://download.csdn.net/download/jzh333/10017044","strategy":"BlogCommendFromQuerySearch","index":"48"}'>
		<a href="https://download.csdn.net/download/jzh333/10017044" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						db2<em>解锁</em>操作					</h4>
					<span class="data float-right">10-12</span>
				</div>
				<div class="desc oneline">
						db2 get snapshot for locks on dbname 查看锁表  application handle
db2 &quot;list applications&quot; 其中appl.handle为锁表进程
db2 ...				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/nadiee/article/details/51259529","strategy":"BlogCommendFromQuerySearch","index":"49"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/nadiee/article/details/51259529","strategy":"BlogCommendFromQuerySearch","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/nadiee/article/details/51259529" target="_blank" title="是否有Root权限">
		<h4 class="text-truncate oneline">
				是否有Root权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-27</span>
				<span class="read-num hover-hide">
					阅读数 
					204</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/nadiee/article/details/51259529" target="_blank" title="是否有Root权限">
				<span class="desc oneline">Processprocess=null;DataOutputStreamos=null;BufferedInputStreambr=null;try{Stringcmd=&quot;ls/data/app&quot;;/...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/nadiee">来自：	<span class="blog_title"> stand up</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtTaIg4sMjctZWR1.html" target="_blank">
                        区块链各种学习</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtjaYg2sNC1lZHUO0O0O.html" target="_blank">
                        python各种模块学习</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/zhangdefeng2008">
              <img src="https://avatar.csdn.net/B/5/8/3_zhangdefeng2008.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/14.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/zhangdefeng2008"  class="" id="uid">zhangdefeng2008</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="31">
                        <dt><a href="https://blog.csdn.net/zhangdefeng2008?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/zhangdefeng2008?t=1"><span class="count">31</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="7">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">7</span></dd>
        </dl>
        <dl class="text-center" title="1">
            <dt>喜欢</dt>
            <dd><span class="count">1</span></dd>
        </dl>
        <dl class="text-center" title="4">
            <dt>评论</dt>
            <dd><span class="count">4</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="3级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-3"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="52645">
                5万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="887">
                887            </dd>
        </dl>
        <dl title="84645">
            <dt>排名：</dt>
            <dd>8万+</dd>
        </dl>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/zhangdefeng2008">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-703","con":",,"}' data-track-click='{"mod":"kp_popu_56-703","con":",,"}' data-report-view='{"mod":"kp_popu_56-703","keyword":""}' data-report-click='{"mod":"kp_popu_56-703","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左上视窗-20181120 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="7700527946"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/zhangdefeng2008/article/details/84461092" target="_blank" >
                                        springmvc-interceptor                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/zhangdefeng2008/article/details/84449945" target="_blank" >
                                        &lt;context:component-scan/&gt;和&lt;mvc:annotation-driven/&gt;的区别                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/zhangdefeng2008/article/details/84446351" target="_blank" >
                                        springmvc实现rest风格webservice                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/zhangdefeng2008/article/details/84443715" target="_blank" >
                                        myBatis高级结果映射resultMap之discriminator                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/zhangdefeng2008/article/details/84440355" target="_blank" >
                                        css圆角样式                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box flexible-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/877255">
                    <span class="title oneline">maven</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/873770">
                    <span class="title oneline">算法</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/878427">
                    <span class="title oneline">struts2</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/879017">
                    <span class="title oneline">JSTL</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/879264">
                    <span class="title oneline">spring</span>
                    <span class="count float-right">11篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/879826">
                    <span class="title oneline">hibernate</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/879827">
                    <span class="title oneline">s2sh</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/879857">
                    <span class="title oneline">事务</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/879864">
                    <span class="title oneline">事务管理</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/879865">
                    <span class="title oneline">apo</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/879866">
                    <span class="title oneline">tx</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/883047">
                    <span class="title oneline">jQuery</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/887224">
                    <span class="title oneline">动态代理</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/887225">
                    <span class="title oneline">cglib</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/905138">
                    <span class="title oneline">Checkstyle</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/960797">
                    <span class="title oneline">hudson deploy plugin</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/1058820">
                    <span class="title oneline">ctx pageContext.request.contextPath</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/1293198">
                    <span class="title oneline">java ftp</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/6014439">
                    <span class="title oneline">log4j</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/6882361">
                    <span class="title oneline">JS</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/6882369">
                    <span class="title oneline">RPC</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/6895268">
                    <span class="title oneline">html</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/6895269">
                    <span class="title oneline">jsp</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/6895288">
                    <span class="title oneline">JavaScript</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/7009772">
                    <span class="title oneline">数据库</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/7388563">
                    <span class="title oneline">Java</span>
                    <span class="count float-right">19篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/7388929">
                    <span class="title oneline">安全</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/7389043">
                    <span class="title oneline">Plupload</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/7446503">
                    <span class="title oneline">mongodb</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/7457103">
                    <span class="title oneline">Eclipse</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/7464824">
                    <span class="title oneline">Java1.8</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/7472994">
                    <span class="title oneline">mysql</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/7494361">
                    <span class="title oneline">Spring boot</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/7515263">
                    <span class="title oneline">搜索引擎</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/7515492">
                    <span class="title oneline">guava</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/7519320">
                    <span class="title oneline">Linux</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/7636192">
                    <span class="title oneline">jvm</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/7722398">
                    <span class="title oneline">注解</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/8424874">
                    <span class="title oneline">jndi</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/8425624">
                    <span class="title oneline">dom4j</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/8425891">
                    <span class="title oneline">css</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/8426441">
                    <span class="title oneline">discriminator</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/8426442">
                    <span class="title oneline">mybatis</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/8426995">
                    <span class="title oneline">springmvc</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhangdefeng2008/article/category/8426996">
                    <span class="title oneline">rest</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideArchive" class="aside-box flexible-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2018/06">
                    2018年6月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2018/05">
                    2018年5月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2018/03">
                    2018年3月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2018/02">
                    2018年2月                    <span class="count float-right">22篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2018/01">
                    2018年1月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2017/07">
                    2017年7月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2017/05">
                    2017年5月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2017/04">
                    2017年4月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2015/12">
                    2015年12月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2013/07">
                    2013年7月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2013/06">
                    2013年6月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2013/05">
                    2013年5月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2012/11">
                    2012年11月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2012/01">
                    2012年1月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2011/12">
                    2011年12月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2011/10">
                    2011年10月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2011/09">
                    2011年9月                    <span class="count float-right">16篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhangdefeng2008/article/month/2011/08">
                    2011年8月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/zhangdefeng2008/article/details/79346811" >
                                                java8 :: 用法 （JDK8 双冒号用法）                    </a>
					<p class="read">阅读数 <span>7291</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/zhangdefeng2008/article/details/7108129" >
                                                hudson插件deploy plugin配置错误                    </a>
					<p class="read">阅读数 <span>4097</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/zhangdefeng2008/article/details/6738398" >
                                                在JSP页面中使用JSTL表达式所需要的包                    </a>
					<p class="read">阅读数 <span>2420</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/zhangdefeng2008/article/details/79591481" >
                                                分布式搜索和分析引擎对比                    </a>
					<p class="read">阅读数 <span>2172</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/zhangdefeng2008/article/details/74518773" >
                                                mysql 各种命令（解锁）                    </a>
					<p class="read">阅读数 <span>2163</span></p>
				</li>
					</ul>
	</div>
</div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/zhangdefeng2008/article/details/79348519#comments">Java8 函数式编程详解</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/sms15732621690" class="user-name" target="_blank">sms15732621690：</a>感谢博主分享                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/zhangdefeng2008/article/details/6741759#comments">在S2SH项目中--把hibern...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/zhimin568" class="user-name" target="_blank">zhimin568：</a>整理的挺好                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/zhangdefeng2008/article/details/7108129#comments">hudson插件deploy pl...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/zhangdefeng2008" class="user-name" target="_blank">zhangdefeng2008：</a>[reply]lhs295988029[/reply]
哪里改成相对地址?                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/zhangdefeng2008/article/details/7108129#comments">hudson插件deploy pl...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/lhs295988029" class="user-name" target="_blank">lhs295988029：</a>写成相对地址就可以了。                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-707","con":",,"}' data-track-click='{"mod":"kp_popu_57-707","con":",,"}' data-report-view='{"mod":"kp_popu_57-707","keyword":""}' data-report-click='{"mod":"kp_popu_57-707","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左下视窗-20181130 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="1894159733"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box ">
			<button class=" low-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">0</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/zhangdefeng2008/article/details/71077690" title="easyui自定义优化">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/zhangdefeng2008/article/details/79002514" title="Spring MVC防御CSRF、XSS和SQL注入攻击">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/zhangdefeng2008/article/details/71077690" title="easyui自定义优化">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/zhangdefeng2008/article/details/79002514" title="Spring MVC防御CSRF、XSS和SQL注入攻击">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "74518773";
    var commentscount = 0;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/zhangdefeng2008/article/details/74518773";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "mysql 各种命令（解锁） - zhangdefeng2008";
    var needInsertBaidu = false;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["mysql","\u5404\u79cd","\u547d\u4ee4","\u89e3\u9501"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

<!-- 高亮未与 markdown兼容  -->
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/chart.css" />
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/lib/chart.min.js"></script>
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/widget2chart.js"></script>
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js?t=20190307095522"></script>


<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
